Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	18448
Missing cells	39534
Missing cells (%)	11.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.2 MiB
Average record size in memory	180.6 B

Variable types

Numeric	11
Categorical	6
Unsupported	1

Alerts

`name` has a high cardinality: 13413 distinct values	High cardinality
`host_name` has a high cardinality: 4863 distinct values	High cardinality
`last_review` has a high cardinality: 2379 distinct values	High cardinality
`license` has a high cardinality: 5510 distinct values	High cardinality
`id` is highly overall correlated with `minimum_nights` and 1 other fields	High correlation
`latitude` is highly overall correlated with `neighbourhood`	High correlation
`longitude` is highly overall correlated with `neighbourhood`	High correlation
`minimum_nights` is highly overall correlated with `id` and 3 other fields	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month` and 1 other fields	High correlation
`reviews_per_month` is highly overall correlated with `id` and 4 other fields	High correlation
`availability_365` is highly overall correlated with `minimum_nights` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly overall correlated with `minimum_nights` and 2 other fields	High correlation
`neighbourhood` is highly overall correlated with `latitude` and 1 other fields	High correlation
`neighbourhood_group` has 18448 (100.0%) missing values	Missing
`last_review` has 4995 (27.1%) missing values	Missing
`reviews_per_month` has 4995 (27.1%) missing values	Missing
`license` has 11094 (60.1%) missing values	Missing
`id` has unique values	Unique
`neighbourhood_group` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`number_of_reviews` has 4995 (27.1%) zeros	Zeros
`availability_365` has 8708 (47.2%) zeros	Zeros
`number_of_reviews_ltm` has 11975 (64.9%) zeros	Zeros

Reproduction

Analysis started	2023-07-17 19:15:21.476322
Analysis finished	2023-07-17 19:16:07.944476
Duration	46.47 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	18448
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1798449 × 10¹⁷

Minimum	61721
Maximum	9.0714141 × 10¹⁷
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	61721
5-th percentile	5843009.2
Q1	19488084
median	36615792
Q3	6.3868683 × 10¹⁷
95-th percentile	8.6548554 × 10¹⁷
Maximum	9.0714141 × 10¹⁷
Range	9.0714141 × 10¹⁷
Interquartile range (IQR)	6.3868683 × 10¹⁷

Descriptive statistics

Standard deviation	3.4968245 × 10¹⁷
Coefficient of variation (CV)	1.6041621
Kurtosis	-0.87006856
Mean	2.1798449 × 10¹⁷
Median Absolute Deviation (MAD)	20130672
Skewness	1.0225948
Sum	-1.2290859 × 10¹⁶
Variance	1.2227782 × 10³⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4688422	1	< 0.1%
46951493	1	< 0.1%
48096183	1	< 0.1%
48083329	1	< 0.1%
48073457	1	< 0.1%
48407995	1	< 0.1%
48705346	1	< 0.1%
48071723	1	< 0.1%
48069317	1	< 0.1%
48401232	1	< 0.1%
Other values (18438)	18438	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
61721	1	< 0.1%
67112	1	< 0.1%
71866	1	< 0.1%
87709	1	< 0.1%
105938	1	< 0.1%
118658	1	< 0.1%
135691	1	< 0.1%
154958	1	< 0.1%
166468	1	< 0.1%
199669	1	< 0.1%

Value	Count	Frequency (%)
9.07141413 × 10¹⁷	1	< 0.1%
9.071356433 × 10¹⁷	1	< 0.1%
9.070776199 × 10¹⁷	1	< 0.1%
9.06835625 × 10¹⁷	1	< 0.1%
9.067403252 × 10¹⁷	1	< 0.1%
9.066886505 × 10¹⁷	1	< 0.1%
9.066534425 × 10¹⁷	1	< 0.1%
9.066069083 × 10¹⁷	1	< 0.1%
9.06410568 × 10¹⁷	1	< 0.1%
9.06319427 × 10¹⁷	1	< 0.1%

name
Categorical

Distinct	13413
Distinct (%)	72.7%
Missing	0
Missing (%)	0.0%
Memory size	288.2 KiB

Rental unit in Bondi Beach · 1 bedroom · 1 bed · 1 bath	122
Rental unit in Bondi Beach · 2 bedrooms · 2 beds · 1 bath	67
Rental unit in Bondi · 1 bedroom · 1 bed · 1 bath	63
Rental unit in Surry Hills · 1 bedroom · 1 bed · 1 bath	58
Rental unit in Manly · 1 bedroom · 1 bed · 1 bath	57
Other values (13408)	18081

Length

Max length	87
Median length	78
Mean length	58.519243
Min length	25

Characters and Unicode

Total characters	1079563
Distinct characters	79
Distinct categories	9 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11700 ?
Unique (%)	63.4%

Sample

1st row	Rental unit in Manly · ★4.71 · 2 bedrooms · 3 beds · 1.5 baths
2nd row	Rental unit in Manly · ★5.0 · 1 bedroom · 1 bed · 1 bath
3rd row	Rental unit in Manly · 1 bedroom · 2 beds · 1 bath
4th row	Guesthouse in Eastwood · 1 bedroom · 1 bed · 1 bath
5th row	Rental unit in Manly · 3 bedrooms · 3 beds · 2 baths

Common Values

Value	Count	Frequency (%)
Rental unit in Bondi Beach · 1 bedroom · 1 bed · 1 bath	122	0.7%
Rental unit in Bondi Beach · 2 bedrooms · 2 beds · 1 bath	67	0.4%
Rental unit in Bondi · 1 bedroom · 1 bed · 1 bath	63	0.3%
Rental unit in Surry Hills · 1 bedroom · 1 bed · 1 bath	58	0.3%
Rental unit in Manly · 1 bedroom · 1 bed · 1 bath	57	0.3%
Rental unit in North Bondi · 1 bedroom · 1 bed · 1 bath	53	0.3%
Rental unit in Coogee · 1 bedroom · 1 bed · 1 bath	52	0.3%
Rental unit in Bondi Beach · 1 bedroom · 1 bed · 1 shared bath	46	0.2%
Rental unit in Randwick · 1 bedroom · 1 bed · 1 bath	42	0.2%
Rental unit in Bondi · 2 bedrooms · 2 beds · 1 bath	41	0.2%
Other values (13403)	17847	96.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
·	65212	24.8%
1	31936	12.1%
in	18448	7.0%
2	12984	4.9%
bath	12797	4.9%
rental	10866	4.1%
unit	10866	4.1%
bedroom	9806	3.7%
bed	9392	3.6%
beds	8791	3.3%
Other values (773)	71820	27.3%

Most occurring characters

Value	Count	Frequency (%)
	244560	22.7%
e	74999	6.9%
·	65212	6.0%
o	57635	5.3%
b	55761	5.2%
n	53905	5.0%
t	53201	4.9%
a	49011	4.5%
d	47940	4.4%
i	42418	3.9%
Other values (69)	334921	31.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	621955	57.6%
Space Separator	244560	22.7%
Decimal Number	81005	7.5%
Other Punctuation	76168	7.1%
Uppercase Letter	45533	4.2%
Other Symbol	10219	0.9%
Dash Punctuation	103	< 0.1%
Other Letter	18	< 0.1%
Control	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	74999	12.1%
o	57635	9.3%
b	55761	9.0%
n	53905	8.7%
t	53201	8.6%
a	49011	7.9%
d	47940	7.7%
i	42418	6.8%
r	34806	5.6%
s	33278	5.4%
Other values (16)	119001	19.1%

Uppercase Letter

Value	Count	Frequency (%)
R	12438	27.3%
H	6435	14.1%
B	5066	11.1%
S	3158	6.9%
C	2952	6.5%
N	2571	5.6%
P	2199	4.8%
M	2039	4.5%
W	1350	3.0%
G	1021	2.2%
Other values (15)	6304	13.8%

Decimal Number

Value	Count	Frequency (%)
1	33741	41.7%
2	14308	17.7%
4	9449	11.7%
3	6116	7.6%
5	6023	7.4%
0	3721	4.6%
7	2169	2.7%
8	2100	2.6%
6	1991	2.5%
9	1387	1.7%

Other Letter

Value	Count	Frequency (%)
悉	5	27.8%
尼	5	27.8%
赫	1	5.6%
斯	1	5.6%
特	1	5.6%
维	1	5.6%
尔	1	5.6%
石	1	5.6%
谷	1	5.6%
市	1	5.6%

Other Punctuation

Value	Count	Frequency (%)
·	65212	85.6%
.	10920	14.3%
,	23	< 0.1%
/	13	< 0.1%

Space Separator

Value	Count	Frequency (%)
	244560	100.0%

Other Symbol

Value	Count	Frequency (%)
★	10219	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	103	100.0%

Control

Value	Count	Frequency (%)
	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	667488	61.8%
Common	412057	38.2%
Han	18	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	74999	11.2%
o	57635	8.6%
b	55761	8.4%
n	53905	8.1%
t	53201	8.0%
a	49011	7.3%
d	47940	7.2%
i	42418	6.4%
r	34806	5.2%
s	33278	5.0%
Other values (41)	164534	24.6%

Common

Value	Count	Frequency (%)
	244560	59.4%
·	65212	15.8%
1	33741	8.2%
2	14308	3.5%
.	10920	2.7%
★	10219	2.5%
4	9449	2.3%
3	6116	1.5%
5	6023	1.5%
0	3721	0.9%
Other values (8)	7788	1.9%

Han

Value	Count	Frequency (%)
悉	5	27.8%
尼	5	27.8%
赫	1	5.6%
斯	1	5.6%
特	1	5.6%
维	1	5.6%
尔	1	5.6%
石	1	5.6%
谷	1	5.6%
市	1	5.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1004114	93.0%
None	65212	6.0%
Misc Symbols	10219	0.9%
CJK	18	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	244560	24.4%
e	74999	7.5%
o	57635	5.7%
b	55761	5.6%
n	53905	5.4%
t	53201	5.3%
a	49011	4.9%
d	47940	4.8%
i	42418	4.2%
r	34806	3.5%
Other values (57)	289878	28.9%

None

Value	Count	Frequency (%)
·	65212	100.0%

Misc Symbols

Value	Count	Frequency (%)
★	10219	100.0%

CJK

Value	Count	Frequency (%)
悉	5	27.8%
尼	5	27.8%
赫	1	5.6%
斯	1	5.6%
特	1	5.6%
维	1	5.6%
尔	1	5.6%
石	1	5.6%
谷	1	5.6%
市	1	5.6%

host_id
Real number (ℝ)

Distinct	13152
Distinct (%)	71.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2794359 × 10⁸

Minimum	21741
Maximum	5.1826875 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	21741
5-th percentile	3452873
Q1	22872668
median	66307957
Q3	1.9515158 × 10⁸
95-th percentile	4.5720651 × 10⁸
Maximum	5.1826875 × 10⁸
Range	5.18247 × 10⁸
Interquartile range (IQR)	1.7227891 × 10⁸

Descriptive statistics

Standard deviation	1.3711254 × 10⁸
Coefficient of variation (CV)	1.071664
Kurtosis	0.5357352
Mean	1.2794359 × 10⁸
Median Absolute Deviation (MAD)	56558594
Skewness	1.2380825
Sum	2.3603033 × 10¹²
Variance	1.8799849 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
279001183	180	1.0%
15739069	141	0.8%
288743418	138	0.7%
7409213	108	0.6%
2450066	83	0.4%
301753450	73	0.4%
16357713	58	0.3%
91961414	55	0.3%
102664004	53	0.3%
474241925	50	0.3%
Other values (13142)	17509	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21741	1	< 0.1%
33294	1	< 0.1%
42647	1	< 0.1%
46116	1	< 0.1%
56410	1	< 0.1%
59850	1	< 0.1%
60582	1	< 0.1%
65554	1	< 0.1%
67766	1	< 0.1%
68133	1	< 0.1%

Value	Count	Frequency (%)
518268746	1	< 0.1%
518116505	1	< 0.1%
517974856	1	< 0.1%
517665755	1	< 0.1%
517662279	1	< 0.1%
517476727	1	< 0.1%
517432477	1	< 0.1%
517115287	1	< 0.1%
517020437	1	< 0.1%
516935257	1	< 0.1%

host_name
Categorical

Distinct	4863
Distinct (%)	26.4%
Missing	2
Missing (%)	< 0.1%
Memory size	288.2 KiB

David	186
MadeComfy	180
Ken	158
The Apartment Service	141
Tim	123
Other values (4858)	17658

Length

Max length	35
Median length	32
Mean length	6.5353464
Min length	1

Characters and Unicode

Total characters	120551
Distinct characters	219
Distinct categories	14 ?
Distinct scripts	6 ?
Distinct blocks	11 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2924 ?
Unique (%)	15.9%

Sample

1st row	Anne
2nd row	Joel
3rd row	Simon
4th row	Ebrahim
5th row	Gemma

Common Values

Value	Count	Frequency (%)
David	186	1.0%
MadeComfy	180	1.0%
Ken	158	0.9%
The Apartment Service	141	0.8%
Tim	123	0.7%
Michael	114	0.6%
James	113	0.6%
L'Abode Accommodation Specialist	108	0.6%
Sarah	99	0.5%
Megan	93	0.5%
Other values (4853)	17131	92.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	207	1.0%
david	203	1.0%
madecomfy	191	0.9%
and	187	0.9%
the	181	0.9%
ken	160	0.8%
apartment	149	0.7%
service	141	0.7%
accommodation	131	0.6%
tim	128	0.6%
Other values (4686)	19614	92.1%

Most occurring characters

Value	Count	Frequency (%)
a	13595	11.3%
e	12299	10.2%
i	9773	8.1%
n	9474	7.9%
r	6542	5.4%
l	5454	4.5%
o	5342	4.4%
t	4162	3.5%
s	3778	3.1%
h	3317	2.8%
Other values (209)	46815	38.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	94986	78.8%
Uppercase Letter	21779	18.1%
Space Separator	2859	2.4%
Other Punctuation	358	0.3%
Other Letter	191	0.2%
Decimal Number	144	0.1%
Dash Punctuation	76	0.1%
Open Punctuation	73	0.1%
Close Punctuation	73	0.1%
Math Symbol	6	< 0.1%
Other values (4)	6	< 0.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
小	20	10.5%
刘	10	5.2%
钱	8	4.2%
丽	6	3.1%
德	5	2.6%
芳	5	2.6%
彼	5	2.6%
敏	3	1.6%
霞	3	1.6%
虹	3	1.6%
Other values (96)	123	64.4%

Lowercase Letter

Value	Count	Frequency (%)
a	13595	14.3%
e	12299	12.9%
i	9773	10.3%
n	9474	10.0%
r	6542	6.9%
l	5454	5.7%
o	5342	5.6%
t	4162	4.4%
s	3778	4.0%
h	3317	3.5%
Other values (42)	21250	22.4%

Uppercase Letter

Value	Count	Frequency (%)
A	2581	11.9%
M	2056	9.4%
S	2038	9.4%
J	1720	7.9%
C	1493	6.9%
L	1175	5.4%
T	1079	5.0%
K	993	4.6%
H	981	4.5%
R	929	4.3%
Other values (22)	6734	30.9%

Decimal Number

Value	Count	Frequency (%)
0	39	27.1%
6	35	24.3%
3	35	24.3%
2	20	13.9%
7	5	3.5%
5	5	3.5%
8	2	1.4%
1	2	1.4%
9	1	0.7%

Other Punctuation

Value	Count	Frequency (%)
&	197	55.0%
'	110	30.7%
:	18	5.0%
.	14	3.9%
/	8	2.2%
,	5	1.4%
;	4	1.1%
@	2	0.6%

Space Separator

Value	Count	Frequency (%)
	2858	> 99.9%
	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	3	50.0%
~	3	50.0%

Final Punctuation

Value	Count	Frequency (%)
’	1	50.0%
”	1	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	76	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	73	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	73	100.0%

Other Symbol

Value	Count	Frequency (%)
☠	2	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
์	1	100.0%

Initial Punctuation

Value	Count	Frequency (%)
“	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	116759	96.9%
Common	3594	3.0%
Han	171	0.1%
Hangul	14	< 0.1%
Thai	7	< 0.1%
Cyrillic	6	< 0.1%

Most frequent character per script

Han

Value	Count	Frequency (%)
小	20	11.7%
刘	10	5.8%
钱	8	4.7%
丽	6	3.5%
德	5	2.9%
芳	5	2.9%
彼	5	2.9%
敏	3	1.8%
霞	3	1.8%
虹	3	1.8%
Other values (79)	103	60.2%

Latin

Value	Count	Frequency (%)
a	13595	11.6%
e	12299	10.5%
i	9773	8.4%
n	9474	8.1%
r	6542	5.6%
l	5454	4.7%
o	5342	4.6%
t	4162	3.6%
s	3778	3.2%
h	3317	2.8%
Other values (68)	43023	36.8%

Common

Value	Count	Frequency (%)
	2858	79.5%
&	197	5.5%
'	110	3.1%
-	76	2.1%
(	73	2.0%
)	73	2.0%
0	39	1.1%
6	35	1.0%
3	35	1.0%
2	20	0.6%
Other values (18)	78	2.2%

Hangul

Value	Count	Frequency (%)
이	2	14.3%
케	2	14.3%
미	2	14.3%
석	1	7.1%
주	1	7.1%
완	1	7.1%
진	1	7.1%
희	1	7.1%
영	1	7.1%
재	1	7.1%

Thai

Value	Count	Frequency (%)
จ	1	14.3%
์	1	14.3%
น	1	14.3%
ต	1	14.3%
เ	1	14.3%
ม	1	14.3%
ส	1	14.3%

Cyrillic

Value	Count	Frequency (%)
м	1	16.7%
е	1	16.7%
т	1	16.7%
р	1	16.7%
А	1	16.7%
З	1	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	120238	99.7%
CJK	171	0.1%
None	104	0.1%
Hangul	14	< 0.1%
Thai	7	< 0.1%
Cyrillic	6	< 0.1%
Punctuation	4	< 0.1%
Misc Symbols	2	< 0.1%
IPA Ext	2	< 0.1%
Phonetic Ext	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	13595	11.3%
e	12299	10.2%
i	9773	8.1%
n	9474	7.9%
r	6542	5.4%
l	5454	4.5%
o	5342	4.4%
t	4162	3.5%
s	3778	3.1%
h	3317	2.8%
Other values (65)	46502	38.7%

None

Value	Count	Frequency (%)
é	37	35.6%
í	23	22.1%
á	7	6.7%
ï	6	5.8%
ë	5	4.8%
ç	3	2.9%
è	3	2.9%
ü	2	1.9%
â	2	1.9%
É	2	1.9%
Other values (11)	14	13.5%

CJK

Value	Count	Frequency (%)
小	20	11.7%
刘	10	5.8%
钱	8	4.7%
丽	6	3.5%
德	5	2.9%
芳	5	2.9%
彼	5	2.9%
敏	3	1.8%
霞	3	1.8%
虹	3	1.8%
Other values (79)	103	60.2%

Misc Symbols

Value	Count	Frequency (%)
☠	2	100.0%

Hangul

Value	Count	Frequency (%)
이	2	14.3%
케	2	14.3%
미	2	14.3%
석	1	7.1%
주	1	7.1%
완	1	7.1%
진	1	7.1%
희	1	7.1%
영	1	7.1%
재	1	7.1%

IPA Ext

Value	Count	Frequency (%)
ʜ	1	50.0%
ɴ	1	50.0%

Punctuation

Value	Count	Frequency (%)
	1	25.0%
’	1	25.0%
”	1	25.0%
“	1	25.0%

Latin Ext Additional

Value	Count	Frequency (%)
ậ	1	100.0%

Cyrillic

Value	Count	Frequency (%)
м	1	16.7%
е	1	16.7%
т	1	16.7%
р	1	16.7%
А	1	16.7%
З	1	16.7%

Phonetic Ext

Value	Count	Frequency (%)
ᴇ	1	50.0%
ᴢ	1	50.0%

Thai

Value	Count	Frequency (%)
จ	1	14.3%
์	1	14.3%
น	1	14.3%
ต	1	14.3%
เ	1	14.3%
ม	1	14.3%
ส	1	14.3%

neighbourhood_group
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	18448
Missing (%)	100.0%
Memory size	288.2 KiB

neighbourhood
Categorical

Distinct	38
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	288.2 KiB

Sydney	4081
Waverley	2395
Randwick	1579
Warringah	927
Manly	815
Other values (33)	8651

Length

Max length	16
Median length	15
Mean length	8.2439289
Min length	4

Characters and Unicode

Total characters	152084
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Manly
2nd row	Manly
3rd row	Manly
4th row	Ryde
5th row	Manly

Common Values

Value	Count	Frequency (%)
Sydney	4081	22.1%
Waverley	2395	13.0%
Randwick	1579	8.6%
Warringah	927	5.0%
Manly	815	4.4%
North Sydney	716	3.9%
Woollahra	682	3.7%
Marrickville	585	3.2%
Pittwater	436	2.4%
Leichhardt	430	2.3%
Other values (28)	5802	31.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sydney	4797	22.8%
waverley	2395	11.4%
randwick	1579	7.5%
warringah	927	4.4%
manly	815	3.9%
north	716	3.4%
woollahra	682	3.2%
bay	655	3.1%
marrickville	585	2.8%
shire	552	2.6%
Other values (35)	7340	34.9%

Most occurring characters

Value	Count	Frequency (%)
a	15261	10.0%
y	15207	10.0%
e	14414	9.5%
r	11365	7.5%
n	11312	7.4%
d	8976	5.9%
l	8781	5.8%
i	7142	4.7%
S	5786	3.8%
h	5126	3.4%
Other values (30)	48714	32.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	127514	83.8%
Uppercase Letter	21509	14.1%
Space Separator	2595	1.7%
Dash Punctuation	466	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	15261	12.0%
y	15207	11.9%
e	14414	11.3%
r	11365	8.9%
n	11312	8.9%
d	8976	7.0%
l	8781	6.9%
i	7142	5.6%
h	5126	4.0%
o	5116	4.0%
Other values (12)	24814	19.5%

Uppercase Letter

Value	Count	Frequency (%)
S	5786	26.9%
W	4302	20.0%
R	2598	12.1%
M	1603	7.5%
B	1570	7.3%
C	949	4.4%
P	894	4.2%
H	759	3.5%
L	719	3.3%
N	716	3.3%
Other values (6)	1613	7.5%

Space Separator

Value	Count	Frequency (%)
	2595	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	466	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	149023	98.0%
Common	3061	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	15261	10.2%
y	15207	10.2%
e	14414	9.7%
r	11365	7.6%
n	11312	7.6%
d	8976	6.0%
l	8781	5.9%
i	7142	4.8%
S	5786	3.9%
h	5126	3.4%
Other values (28)	45653	30.6%

Common

Value	Count	Frequency (%)
	2595	84.8%
-	466	15.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	152084	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	15261	10.0%
y	15207	10.0%
e	14414	9.5%
r	11365	7.5%
n	11312	7.4%
d	8976	5.9%
l	8781	5.8%
i	7142	4.7%
S	5786	3.8%
h	5126	3.4%
Other values (30)	48714	32.0%

latitude
Real number (ℝ)

Distinct	13069
Distinct (%)	70.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-33.862176

Minimum	-34.10068
Maximum	-33.38364
Zeros	0
Zeros (%)	0.0%
Negative	18448
Negative (%)	100.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	-34.10068
5-th percentile	-33.953559
Q1	-33.899813
median	-33.88144
Q3	-33.824727
95-th percentile	-33.724781
Maximum	-33.38364
Range	0.71704
Interquartile range (IQR)	0.07508581

Descriptive statistics

Standard deviation	0.074203505
Coefficient of variation (CV)	-0.0021913389
Kurtosis	3.0280169
Mean	-33.862176
Median Absolute Deviation (MAD)	0.03051
Skewness	0.98575803
Sum	-624689.43
Variance	0.0055061602
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-33.87907	11	0.1%
-33.8703262	11	0.1%
-33.88442	8	< 0.1%
-33.89442	8	< 0.1%
-33.88788	8	< 0.1%
-33.89327	8	< 0.1%
-33.88842	8	< 0.1%
-33.88956	8	< 0.1%
-33.89111	8	< 0.1%
-33.88686	8	< 0.1%
Other values (13059)	18362	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-34.10068	1	< 0.1%
-34.09723	1	< 0.1%
-34.09583546	1	< 0.1%
-34.09492127	1	< 0.1%
-34.0933507	1	< 0.1%
-34.09202	1	< 0.1%
-34.09055273	1	< 0.1%
-34.09018	1	< 0.1%
-34.08999	1	< 0.1%
-34.08928	1	< 0.1%

Value	Count	Frequency (%)
-33.38364	1	< 0.1%
-33.39315033	1	< 0.1%
-33.40049081	1	< 0.1%
-33.4005	1	< 0.1%
-33.4007165	1	< 0.1%
-33.40116	1	< 0.1%
-33.40141215	1	< 0.1%
-33.40165438	1	< 0.1%
-33.40289	1	< 0.1%
-33.40294706	1	< 0.1%

longitude
Real number (ℝ)

Distinct	14087
Distinct (%)	76.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	151.18704

Minimum	150.63049
Maximum	151.33907
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	150.63049
5-th percentile	150.98772
Q1	151.15303
median	151.20987
Q3	151.25613
95-th percentile	151.28774
Maximum	151.33907
Range	0.70857614
Interquartile range (IQR)	0.10310749

Descriptive statistics

Standard deviation	0.099900267
Coefficient of variation (CV)	0.00066077268
Kurtosis	4.5594871
Mean	151.18704
Median Absolute Deviation (MAD)	0.049758282
Skewness	-1.8622636
Sum	2789098.6
Variance	0.0099800633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
151.1968183	11	0.1%
151.20961	10	0.1%
151.20627	10	0.1%
151.20694	9	< 0.1%
151.2137	9	< 0.1%
151.28153	8	< 0.1%
151.20459	7	< 0.1%
151.21252	7	< 0.1%
151.21417	7	< 0.1%
151.20978	7	< 0.1%
Other values (14077)	18363	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
150.63049	1	< 0.1%
150.64493	1	< 0.1%
150.65164	1	< 0.1%
150.65301	1	< 0.1%
150.6600379	1	< 0.1%
150.66007	1	< 0.1%
150.6623881	1	< 0.1%
150.66291	1	< 0.1%
150.66316	1	< 0.1%
150.663324	1	< 0.1%

Value	Count	Frequency (%)
151.3390661	1	< 0.1%
151.33877	1	< 0.1%
151.3387	1	< 0.1%
151.33836	1	< 0.1%
151.3381773	1	< 0.1%
151.33812	1	< 0.1%
151.33774	1	< 0.1%
151.33773	1	< 0.1%
151.3375356	1	< 0.1%
151.337494	1	< 0.1%

room_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	288.2 KiB

Entire home/apt	12035
Private room	6085
Shared room	267
Hotel room	61

Length

Max length	15
Median length	15
Mean length	13.936036
Min length	10

Characters and Unicode

Total characters	257092
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Entire home/apt
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	12035	65.2%
Private room	6085	33.0%
Shared room	267	1.4%
Hotel room	61	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	12035	32.6%
home/apt	12035	32.6%
room	6413	17.4%
private	6085	16.5%
shared	267	0.7%
hotel	61	0.2%

Most occurring characters

Value	Count	Frequency (%)
e	30483	11.9%
t	30216	11.8%
o	24922	9.7%
r	24800	9.6%
m	18448	7.2%
	18448	7.2%
a	18387	7.2%
i	18120	7.0%
h	12302	4.8%
p	12035	4.7%
Other values (9)	48931	19.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	208161	81.0%
Space Separator	18448	7.2%
Uppercase Letter	18448	7.2%
Other Punctuation	12035	4.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	30483	14.6%
t	30216	14.5%
o	24922	12.0%
r	24800	11.9%
m	18448	8.9%
a	18387	8.8%
i	18120	8.7%
h	12302	5.9%
p	12035	5.8%
n	12035	5.8%
Other values (3)	6413	3.1%

Uppercase Letter

Value	Count	Frequency (%)
E	12035	65.2%
P	6085	33.0%
S	267	1.4%
H	61	0.3%

Space Separator

Value	Count	Frequency (%)
	18448	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	12035	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	226609	88.1%
Common	30483	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	30483	13.5%
t	30216	13.3%
o	24922	11.0%
r	24800	10.9%
m	18448	8.1%
a	18387	8.1%
i	18120	8.0%
h	12302	5.4%
p	12035	5.3%
E	12035	5.3%
Other values (7)	24861	11.0%

Common

Value	Count	Frequency (%)
	18448	60.5%
/	12035	39.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	257092	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	30483	11.9%
t	30216	11.8%
o	24922	9.7%
r	24800	9.6%
m	18448	7.2%
	18448	7.2%
a	18387	7.2%
i	18120	7.0%
h	12302	4.8%
p	12035	4.7%
Other values (9)	48931	19.0%

price
Real number (ℝ)

Distinct	571
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	187.14094

Minimum	18
Maximum	600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	18
5-th percentile	45
Q1	88
median	151
Q3	250
95-th percentile	464
Maximum	600
Range	582
Interquartile range (IQR)	162

Descriptive statistics

Standard deviation	128.26091
Coefficient of variation (CV)	0.68537065
Kurtosis	0.8657649
Mean	187.14094
Median Absolute Deviation (MAD)	74
Skewness	1.1587823
Sum	3452376
Variance	16450.86
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150	565	3.1%
100	555	3.0%
200	469	2.5%
250	417	2.3%
50	394	2.1%
60	368	2.0%
70	351	1.9%
120	350	1.9%
300	343	1.9%
80	341	1.8%
Other values (561)	14295	77.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18	4	< 0.1%
19	4	< 0.1%
20	12	0.1%
21	2	< 0.1%
22	9	< 0.1%
23	4	< 0.1%
24	3	< 0.1%
25	26	0.1%
26	9	< 0.1%
27	7	< 0.1%

Value	Count	Frequency (%)
600	123	0.7%
599	11	0.1%
597	2	< 0.1%
596	3	< 0.1%
595	8	< 0.1%
593	2	< 0.1%
592	2	< 0.1%
591	4	< 0.1%
590	15	0.1%
589	2	< 0.1%

minimum_nights
Real number (ℝ)

Distinct	41
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.947853

Minimum	1
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	90
Q3	90
95-th percentile	90
Maximum	90
Range	89
Interquartile range (IQR)	87

Descriptive statistics

Standard deviation	42.573702
Coefficient of variation (CV)	0.80406851
Kurtosis	-1.8913261
Mean	52.947853
Median Absolute Deviation (MAD)	0
Skewness	-0.29436489
Sum	976782
Variance	1812.5201
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
90	10433	56.6%
2	2538	13.8%
1	1725	9.4%
3	1340	7.3%
4	555	3.0%
5	517	2.8%
7	500	2.7%
28	233	1.3%
14	145	0.8%
21	102	0.6%
Other values (31)	360	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1725	9.4%
2	2538	13.8%
3	1340	7.3%
4	555	3.0%
5	517	2.8%
6	81	0.4%
7	500	2.7%
8	10	0.1%
9	4	< 0.1%
10	71	0.4%

Value	Count	Frequency (%)
90	10433	56.6%
89	5	< 0.1%
85	1	< 0.1%
84	4	< 0.1%
80	1	< 0.1%
70	2	< 0.1%
65	2	< 0.1%
60	30	0.2%
59	1	< 0.1%
50	1	< 0.1%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	51
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.7647441

Minimum	0
Maximum	50
Zeros	4995
Zeros (%)	27.1%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	10
95-th percentile	35
Maximum	50
Range	50
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	11.312058
Coefficient of variation (CV)	1.4568487
Kurtosis	2.7305088
Mean	7.7647441
Median Absolute Deviation (MAD)	2
Skewness	1.8546245
Sum	143244
Variance	127.96265
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4995	27.1%
1	2730	14.8%
2	1561	8.5%
3	1130	6.1%
4	821	4.5%
5	642	3.5%
6	485	2.6%
8	452	2.5%
7	447	2.4%
10	332	1.8%
Other values (41)	4853	26.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4995	27.1%
1	2730	14.8%
2	1561	8.5%
3	1130	6.1%
4	821	4.5%
5	642	3.5%
6	485	2.6%
7	447	2.4%
8	452	2.5%
9	324	1.8%

Value	Count	Frequency (%)
50	48	0.3%
49	40	0.2%
48	57	0.3%
47	53	0.3%
46	56	0.3%
45	57	0.3%
44	40	0.2%
43	61	0.3%
42	58	0.3%
41	60	0.3%

last_review
Categorical

HIGH CARDINALITY MISSING

Distinct	2379
Distinct (%)	17.7%
Missing	4995
Missing (%)	27.1%
Memory size	288.2 KiB

2023-06-04	213
2023-05-21	213
2023-05-28	204
2023-05-20	148
2023-05-22	136
Other values (2374)	12539

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	134530
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	743 ?
Unique (%)	5.5%

Sample

1st row	2023-01-28
2nd row	2019-12-12
3rd row	2018-01-06
4th row	2023-05-31
5th row	2014-10-31

Common Values

Value	Count	Frequency (%)
2023-06-04	213	1.2%
2023-05-21	213	1.2%
2023-05-28	204	1.1%
2023-05-20	148	0.8%
2023-05-22	136	0.7%
2023-05-07	136	0.7%
2023-05-29	120	0.7%
2023-06-03	110	0.6%
2023-05-27	105	0.6%
2023-05-14	105	0.6%
Other values (2369)	11963	64.8%
(Missing)	4995	27.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2023-06-04	213	1.6%
2023-05-21	213	1.6%
2023-05-28	204	1.5%
2023-05-20	148	1.1%
2023-05-22	136	1.0%
2023-05-07	136	1.0%
2023-05-29	120	0.9%
2023-06-03	110	0.8%
2023-05-27	105	0.8%
2023-05-14	105	0.8%
Other values (2369)	11963	88.9%

Most occurring characters

Value	Count	Frequency (%)
0	32943	24.5%
2	30451	22.6%
-	26906	20.0%
1	15561	11.6%
3	9509	7.1%
5	4527	3.4%
9	3141	2.3%
4	3135	2.3%
6	2922	2.2%
8	2888	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	107624	80.0%
Dash Punctuation	26906	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	32943	30.6%
2	30451	28.3%
1	15561	14.5%
3	9509	8.8%
5	4527	4.2%
9	3141	2.9%
4	3135	2.9%
6	2922	2.7%
8	2888	2.7%
7	2547	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	26906	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	134530	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	32943	24.5%
2	30451	22.6%
-	26906	20.0%
1	15561	11.6%
3	9509	7.1%
5	4527	3.4%
9	3141	2.3%
4	3135	2.3%
6	2922	2.2%
8	2888	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	134530	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	32943	24.5%
2	30451	22.6%
-	26906	20.0%
1	15561	11.6%
3	9509	7.1%
5	4527	3.4%
9	3141	2.3%
4	3135	2.3%
6	2922	2.2%
8	2888	2.1%

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	565
Distinct (%)	4.2%
Missing	4995
Missing (%)	27.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.7305456

Minimum	0.01
Maximum	13.58
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.01
Q1	0.05
median	0.23
Q3	0.99
95-th percentile	3
Maximum	13.58
Range	13.57
Interquartile range (IQR)	0.94

Descriptive statistics

Standard deviation	1.1213069
Coefficient of variation (CV)	1.5348897
Kurtosis	11.602099
Mean	0.7305456
Median Absolute Deviation (MAD)	0.21
Skewness	2.7905134
Sum	9828.03
Variance	1.2573292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	1379	7.5%
0.01	744	4.0%
0.03	620	3.4%
0.04	550	3.0%
0.05	476	2.6%
0.06	360	2.0%
0.07	351	1.9%
1	225	1.2%
0.08	223	1.2%
0.09	208	1.1%
Other values (555)	8317	45.1%
(Missing)	4995	27.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	744	4.0%
0.02	1379	7.5%
0.03	620	3.4%
0.04	550	3.0%
0.05	476	2.6%
0.06	360	2.0%
0.07	351	1.9%
0.08	223	1.2%
0.09	208	1.1%
0.1	195	1.1%

Value	Count	Frequency (%)
13.58	1	< 0.1%
13.47	1	< 0.1%
10.78	1	< 0.1%
10.14	1	< 0.1%
10	1	< 0.1%
9.6	1	< 0.1%
9.47	1	< 0.1%
9.38	1	< 0.1%
9.31	1	< 0.1%
9.09	1	< 0.1%

calculated_host_listings_count
Real number (ℝ)

Distinct	57
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.252385

Minimum	1
Maximum	229
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	56
Maximum	229
Range	228
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	33.554656
Coefficient of variation (CV)	2.9820039
Kurtosis	22.649521
Mean	11.252385
Median Absolute Deviation (MAD)	0
Skewness	4.6335124
Sum	207584
Variance	1125.9149
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	11161	60.5%
2	2138	11.6%
3	750	4.1%
4	440	2.4%
5	286	1.6%
7	246	1.3%
6	210	1.1%
229	180	1.0%
145	141	0.8%
10	141	0.8%
Other values (47)	2755	14.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11161	60.5%
2	2138	11.6%
3	750	4.1%
4	440	2.4%
5	286	1.6%
6	210	1.1%
7	246	1.3%
8	136	0.7%
9	121	0.7%
10	141	0.8%

Value	Count	Frequency (%)
229	180	1.0%
176	108	0.6%
155	138	0.7%
145	141	0.8%
102	58	0.3%
96	83	0.4%
80	1	< 0.1%
78	73	0.4%
64	55	0.3%
57	40	0.2%

availability_365
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	366
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.736882

Minimum	0
Maximum	365
Zeros	8708
Zeros (%)	47.2%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	20
Q3	167
95-th percentile	363
Maximum	365
Range	365
Interquartile range (IQR)	167

Descriptive statistics

Standard deviation	124.32439
Coefficient of variation (CV)	1.3123125
Kurtosis	-0.23182098
Mean	94.736882
Median Absolute Deviation (MAD)	20
Skewness	1.0935197
Sum	1747706
Variance	15456.555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8708	47.2%
90	530	2.9%
365	527	2.9%
364	351	1.9%
89	240	1.3%
179	214	1.2%
180	157	0.9%
363	119	0.6%
84	114	0.6%
91	106	0.6%
Other values (356)	7382	40.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8708	47.2%
1	57	0.3%
2	30	0.2%
3	39	0.2%
4	40	0.2%
5	35	0.2%
6	20	0.1%
7	13	0.1%
8	26	0.1%
9	20	0.1%

Value	Count	Frequency (%)
365	527	2.9%
364	351	1.9%
363	119	0.6%
362	80	0.4%
361	36	0.2%
360	40	0.2%
359	26	0.1%
358	78	0.4%
357	28	0.2%
356	33	0.2%

number_of_reviews_ltm
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	51
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4599415

Minimum	0
Maximum	50
Zeros	11975
Zeros (%)	64.9%
Negative	0
Negative (%)	0.0%
Memory size	288.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	20
Maximum	50
Range	50
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	7.2846708
Coefficient of variation (CV)	2.1054318
Kurtosis	8.5540453
Mean	3.4599415
Median Absolute Deviation (MAD)	0
Skewness	2.7946285
Sum	63829
Variance	53.066428
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11975	64.9%
1	912	4.9%
2	665	3.6%
3	498	2.7%
4	415	2.2%
5	368	2.0%
6	295	1.6%
7	289	1.6%
8	289	1.6%
9	252	1.4%
Other values (41)	2490	13.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11975	64.9%
1	912	4.9%
2	665	3.6%
3	498	2.7%
4	415	2.2%
5	368	2.0%
6	295	1.6%
7	289	1.6%
8	289	1.6%
9	252	1.4%

Value	Count	Frequency (%)
50	4	< 0.1%
49	7	< 0.1%
48	4	< 0.1%
47	6	< 0.1%
46	8	< 0.1%
45	8	< 0.1%
44	4	< 0.1%
43	13	0.1%
42	5	< 0.1%
41	11	0.1%

license
Categorical

HIGH CARDINALITY MISSING

Distinct	5510
Distinct (%)	74.9%
Missing	11094
Missing (%)	60.1%
Memory size	288.2 KiB

Exempt	1390
PID-STRA-27027	25
PID-STRA-49937	22
PID-STRA-38401	13
A.B.N.57 002 964 669	10
Other values (5505)	5894

Length

Max length	20
Median length	14
Mean length	12.496872
Min length	6

Characters and Unicode

Total characters	91902
Distinct characters	28
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5242 ?
Unique (%)	71.3%

Sample

1st row	PID-STRA-26284
2nd row	PID-STRA-26166
3rd row	PID-STRA-51614
4th row	PID-STRA-45916
5th row	PID-STRA-49889

Common Values

Value	Count	Frequency (%)
Exempt	1390	7.5%
PID-STRA-27027	25	0.1%
PID-STRA-49937	22	0.1%
PID-STRA-38401	13	0.1%
A.B.N.57 002 964 669	10	0.1%
PID-STRA-44538	10	0.1%
PID-STRA-6133-1	10	0.1%
PID-STRA-41992	10	0.1%
PID-STRA-1237	10	0.1%
PID-STRA-29404	9	< 0.1%
Other values (5500)	5845	31.7%
(Missing)	11094	60.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
exempt	1390	18.8%
pid-stra-27027	25	0.3%
pid-stra-49937	22	0.3%
pid-stra-38401	13	0.2%
a.b.n.57	10	0.1%
002	10	0.1%
964	10	0.1%
669	10	0.1%
pid-stra-44538	10	0.1%
pid-stra-6133-1	10	0.1%
Other values (5503)	5874	79.6%

Most occurring characters

Value	Count	Frequency (%)
-	12202	13.3%
A	5964	6.5%
P	5954	6.5%
I	5954	6.5%
D	5954	6.5%
S	5954	6.5%
T	5954	6.5%
R	5954	6.5%
4	4374	4.8%
3	3542	3.9%
Other values (18)	30096	32.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	43098	46.9%
Decimal Number	29592	32.2%
Dash Punctuation	12202	13.3%
Lowercase Letter	6950	7.6%
Other Punctuation	30	< 0.1%
Space Separator	30	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	5964	13.8%
P	5954	13.8%
I	5954	13.8%
D	5954	13.8%
S	5954	13.8%
T	5954	13.8%
R	5954	13.8%
E	1390	3.2%
B	10	< 0.1%
N	10	< 0.1%

Decimal Number

Value	Count	Frequency (%)
4	4374	14.8%
3	3542	12.0%
1	3299	11.1%
2	3241	11.0%
5	3016	10.2%
9	2508	8.5%
7	2470	8.3%
6	2392	8.1%
0	2386	8.1%
8	2364	8.0%

Lowercase Letter

Value	Count	Frequency (%)
x	1390	20.0%
t	1390	20.0%
p	1390	20.0%
m	1390	20.0%
e	1390	20.0%

Dash Punctuation

Value	Count	Frequency (%)
-	12202	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	30	100.0%

Space Separator

Value	Count	Frequency (%)
	30	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50048	54.5%
Common	41854	45.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	5964	11.9%
P	5954	11.9%
I	5954	11.9%
D	5954	11.9%
S	5954	11.9%
T	5954	11.9%
R	5954	11.9%
x	1390	2.8%
t	1390	2.8%
p	1390	2.8%
Other values (5)	4190	8.4%

Common

Value	Count	Frequency (%)
-	12202	29.2%
4	4374	10.5%
3	3542	8.5%
1	3299	7.9%
2	3241	7.7%
5	3016	7.2%
9	2508	6.0%
7	2470	5.9%
6	2392	5.7%
0	2386	5.7%
Other values (3)	2424	5.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	91902	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	12202	13.3%
A	5964	6.5%
P	5954	6.5%
I	5954	6.5%
D	5954	6.5%
S	5954	6.5%
T	5954	6.5%
R	5954	6.5%
4	4374	4.8%
3	3542	3.9%
Other values (18)	30096	32.7%

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	neighbourhood	room_type
id	1.000	0.438	0.085	-0.160	0.253	-0.653	0.036	0.705	0.368	0.454	0.482	0.099	0.144
host_id	0.438	1.000	0.053	-0.295	-0.017	-0.260	0.035	0.307	0.216	0.221	0.205	0.134	0.114
latitude	0.085	0.053	1.000	0.057	0.148	-0.124	0.046	0.100	0.047	0.116	0.090	0.634	0.075
longitude	-0.160	-0.295	0.057	1.000	0.240	0.109	-0.049	-0.151	-0.157	-0.159	-0.085	0.715	0.112
price	0.253	-0.017	0.148	0.240	1.000	-0.377	0.119	0.303	0.132	0.269	0.311	0.113	0.405
minimum_nights	-0.653	-0.260	-0.124	0.109	-0.377	1.000	-0.367	-0.760	-0.417	-0.525	-0.771	0.088	0.176
number_of_reviews	0.036	0.035	0.046	-0.049	0.119	-0.367	1.000	0.682	0.198	0.195	0.630	0.044	0.108
reviews_per_month	0.705	0.307	0.100	-0.151	0.303	-0.760	0.682	1.000	0.379	0.527	0.838	0.070	0.086
calculated_host_listings_count	0.368	0.216	0.047	-0.157	0.132	-0.417	0.198	0.379	1.000	0.328	0.369	0.144	0.113
availability_365	0.454	0.221	0.116	-0.159	0.269	-0.525	0.195	0.527	0.328	1.000	0.474	0.106	0.128
number_of_reviews_ltm	0.482	0.205	0.090	-0.085	0.311	-0.771	0.630	0.838	0.369	0.474	1.000	0.054	0.102
neighbourhood	0.099	0.134	0.634	0.715	0.113	0.088	0.044	0.070	0.144	0.106	0.054	1.000	0.146
room_type	0.144	0.114	0.075	0.112	0.405	0.176	0.108	0.086	0.113	0.128	0.102	0.146	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
0	4688422	Rental unit in Manly · ★4.71 · 2 bedrooms · 3 beds · 1.5 baths	13396297	Anne	NaN	Manly	-33.80560	151.28433	Entire home/apt	300	1	36	2023-01-28	0.35	1	31	13	PID-STRA-26284
1	39681254	Rental unit in Manly · ★5.0 · 1 bedroom · 1 bed · 1 bath	25316226	Joel	NaN	Manly	-33.80512	151.28907	Entire home/apt	110	90	3	2019-12-12	0.07	1	0	0	NaN
2	22314790	Rental unit in Manly · 1 bedroom · 2 beds · 1 bath	48897764	Simon	NaN	Manly	-33.79627	151.28476	Entire home/apt	190	90	1	2018-01-06	0.02	1	0	0	NaN
3	39446599	Guesthouse in Eastwood · 1 bedroom · 1 bed · 1 bath	152329169	Ebrahim	NaN	Ryde	-33.78597	151.09255	Entire home/apt	70	90	0	NaN	NaN	1	0	0	PID-STRA-26166
6	43619457	Rental unit in Manly · 3 bedrooms · 3 beds · 2 baths	26816558	Gemma	NaN	Manly	-33.79515	151.28498	Entire home/apt	560	90	0	NaN	NaN	2	0	0	NaN
7	892848682006777431	Cabin in Queenscliff · ★New · Studio · 1 bed · 1 bath	514356697	Justine	NaN	Manly	-33.78488	151.28432	Entire home/apt	249	2	0	NaN	NaN	1	239	0	PID-STRA-51614
8	44067842	Home in Fairlight · 3 bedrooms · 2 beds · 2.5 baths	4170245	Irmke	NaN	Manly	-33.79209	151.27732	Entire home/apt	234	3	0	NaN	NaN	3	54	0	PID-STRA-45916
9	845977275219873014	Rental unit in West Ryde · ★4.67 · 1 bedroom · 1 bed · 1 bath	4860812	Kirrili	NaN	Ryde	-33.81324	151.08791	Entire home/apt	120	1	9	2023-05-31	3.65	1	118	9	PID-STRA-49889
13	363237	Rental unit in Summer Hill · ★4.67 · 1 bedroom · 1 bed · 1 bath	1835730	Mina	NaN	Ashfield	-33.88749	151.14016	Entire home/apt	85	90	3	2014-10-31	0.03	1	0	0	NaN
24	61721	Rental unit in Bondi Beach · ★4.42 · 2 bedrooms · 2 beds · 1 bath	299170	Eilish	NaN	Waverley	-33.88905	151.27653	Entire home/apt	245	90	33	2021-04-07	0.22	1	309	0	NaN

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	last_review	reviews_per_month	calculated_host_listings_count	availability_365	license
23438	906319427002029747	Guesthouse in Edmondson Park · ★New · 2 bedrooms · 2 beds · 1 bath	514670320	Abdu	NaN	Liverpool	-33.954348	150.862190	Entire home/apt	160	1	NaN	NaN	1	364	Exempt
23439	901396902037093809	Camper/RV in Canley Heights · ★New · 1 bedroom · 2 beds · 1 bath	304795574	Huong Thien Nguyen	NaN	Fairfield	-33.880299	150.918334	Private room	46	1	NaN	NaN	14	362	Exempt
23440	906410567979085806	Rental unit in Waterloo · ★New · 1 bedroom · 1 bed · 1 bath	324511820	Dong	NaN	Sydney	-33.900515	151.213841	Entire home/apt	126	21	NaN	NaN	19	168	Exempt
23441	901624777811095209	Rental unit in Arncliffe · ★New · 1 bedroom · 2 beds · 1 bath	468475474	Bo	NaN	Rockdale	-33.937568	151.148187	Entire home/apt	177	1	NaN	NaN	2	89	PID-STRA-52346
23442	906606908279819571	Bed and breakfast in Avalon Beach · ★New · 1 bedroom · 11 beds · 1.5 shared baths	72844643	Oliver & Verena	NaN	Pittwater	-33.643023	151.326208	Private room	239	1	NaN	NaN	3	297	PID-STRA-4020-2
23443	906653442464491046	Rental unit in Manly · ★New · 1 bedroom · 1 bed · 1 bath	40340765	Lisa	NaN	Manly	-33.801220	151.287630	Entire home/apt	152	21	NaN	NaN	2	89	PID-STRA-35713
23444	906688650475677230	Home in Rozelle · ★New · 2 bedrooms · 3 beds · 1 bath	38478183	Guest Realty	NaN	Leichhardt	-33.867070	151.166530	Entire home/apt	347	2	NaN	NaN	35	356	PID-STRA-52428
23446	906740325185303171	Home in Banksmeadow · ★New · 1 bedroom · 1 bed · 1 bath	518268746	Cherilynn	NaN	Botany Bay	-33.941845	151.211888	Private room	99	1	NaN	NaN	1	364	PID-STRA-39654
23449	906835624973815512	Rental unit in Wentworth Point · ★New · 2 bedrooms · 3 beds · 2 baths	474434658	Short Term Accommodation Management	NaN	Auburn	-33.825167	151.078528	Entire home/apt	240	3	NaN	NaN	5	0	PID-STRA-52734
23450	907077619932231671	Home in Millers Point · ★New · 2 bedrooms · 2 beds · 1 bath	510052112	Haihao	NaN	Sydney	-33.875670	151.204620	Entire home/apt	199	1	NaN	NaN	1	148	Exempt

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Letter

Other Punctuation

Space Separator

Other Symbol

Dash Punctuation

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Han

Most occurring blocks

Most frequent character per block

ASCII

None

Misc Symbols

CJK

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Math Symbol

Final Punctuation

Dash Punctuation

Open Punctuation

Close Punctuation

Other Symbol

Nonspacing Mark

Initial Punctuation

Most occurring scripts

Most frequent character per script

Han

Latin

Common

Hangul

Thai

Cyrillic

Most occurring blocks

Most frequent character per block

ASCII

None

CJK

Misc Symbols

Hangul

IPA Ext

Punctuation

Latin Ext Additional

Cyrillic

Phonetic Ext

Thai

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common